// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   file_draft_ok.java

package draft.hr;

import com.jspsmart.upload.*;
import include.get_sql.getInsertSql;
import include.nseer_cookie.*;
import include.nseer_db.nseer_db_backup1;
import include.operateDB.CdefineUpdate;
import java.io.IOException;
import java.sql.ResultSet;
import java.util.StringTokenizer;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;
import validata.ValidataTag;

public class file_draft_ok extends HttpServlet
{

	ServletContext application;
	HttpSession session;
	nseer_db_backup1 erp_db;

	public file_draft_ok()
	{
		erp_db = null;
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			java.io.PrintWriter out = response.getWriter();
			nseer_db_backup1 hr_db = new nseer_db_backup1(dbApplication);
			getInsertSql getInsertSql = new getInsertSql();
			ValidataTag vt = new ValidataTag();
			if (hr_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				String tag = request.getParameter("tag");
				if (tag.equals("0"))
				{
					String kind_chain = request.getParameter("kind_chain");
					String chain_id = Divide1.getId(kind_chain);
					String chain_name = Divide1.getName(kind_chain);
					String major_first_kind_ID = "";
					String major_first_kind_name = "";
					String major_second_kind_ID = "";
					String major_second_kind_name = "";
					String major_second_kind = request.getParameter("select5");
					String major_first_kind = request.getParameter("select4");
					for (StringTokenizer tokenTO4 = new StringTokenizer(major_first_kind, "/"); tokenTO4.hasMoreTokens();)
					{
						major_first_kind_ID = tokenTO4.nextToken();
						major_first_kind_name = tokenTO4.nextToken();
					}

					for (StringTokenizer tokenTO5 = new StringTokenizer(major_second_kind, "/"); tokenTO5.hasMoreTokens();)
					{
						major_second_kind_ID = tokenTO5.nextToken();
						major_second_kind_name = tokenTO5.nextToken();
					}

					String oldKind_chain = request.getParameter("oldKind_chain");
					String oldChain_id = Divide1.getId(oldKind_chain);
					String human_ID = request.getParameter("human_ID");
					String human_name = request.getParameter("human_name");
					String human_address = request.getParameter("human_address");
					String human_title_class = request.getParameter("human_title_class");
					String human_bank = request.getParameter("human_bank");
					String human_account = request.getParameter("human_account");
					String human_tel = request.getParameter("human_tel");
					String human_home_tel = request.getParameter("human_home_tel");
					String human_postcode = request.getParameter("human_postcode");
					String register = request.getParameter("register");
					String human_cellphone = request.getParameter("human_cellphone");
					String idcard = request.getParameter("idcard");
					String SIN = request.getParameter("SIN");
					String religion = request.getParameter("religion");
					String party = request.getParameter("party");
					String race = request.getParameter("race");
					String nationality = request.getParameter("nationality");
					String age = request.getParameter("age");
					String sex = request.getParameter("sex");
					String speciality = request.getParameter("speciality");
					String hobby = request.getParameter("hobby");
					String birthday = request.getParameter("birthday");
					if (birthday.equals(""))
						birthday = "1800-01-01";
					String birthplace = request.getParameter("birthplace");
					String human_email = request.getParameter("human_email");
					String educated_degree = request.getParameter("educated_degree");
					String educated_years = request.getParameter("educated_years");
					String educated_major = request.getParameter("educated_major");
					String register_time = request.getParameter("register_time");
					String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
					String remark = exchange.toHtml(bodyc);
					String bodya = new String(request.getParameter("history_records").getBytes("UTF-8"), "UTF-8");
					String history_records = exchange.toHtml(bodya);
					String bodyb = new String(request.getParameter("family_membership").getBytes("UTF-8"), "UTF-8");
					String family_membership = exchange.toHtml(bodyb);
					String salary_standard_ID = "";
					String salary_standard_name = "";
					String salary_sum = "";
					String salary_standard = request.getParameter("salary_standard");
					for (StringTokenizer tokenTO6 = new StringTokenizer(salary_standard, "/"); tokenTO6.hasMoreTokens();)
					{
						salary_standard_ID = tokenTO6.nextToken();
						salary_standard_name = tokenTO6.nextToken();
						salary_sum = tokenTO6.nextToken();
					}

					String column_group = getInsertSql.sql((String)dbSession.getAttribute("unit_db_name"), "hr_file");
					if (vt.validata((String)dbSession.getAttribute("unit_db_name"), "hr_file", "human_ID", human_ID, "check_tag").equals("5") || vt.validata((String)dbSession.getAttribute("unit_db_name"), "hr_file", "human_ID", human_ID, "check_tag").equals("9"))
						try
						{
							String sql8 = (new StringBuilder("update hr_file set chain_id='")).append(chain_id).append("',chain_name='").append(chain_name).append("',human_major_first_kind_ID='").append(major_first_kind_ID).append("',human_major_first_kind_name='").append(major_first_kind_name).append("',human_major_second_kind_ID='").append(major_second_kind_ID).append("',human_major_second_kind_name='").append(major_second_kind_name).append("',human_name='").append(human_name).append("',human_address='").append(human_address).append("',human_title_class='").append(human_title_class).append("',human_bank='").append(human_bank).append("',human_account='").append(human_account).append("',human_tel='").append(human_tel).append("',human_home_tel='").append(human_home_tel).append("',human_postcode='").append(human_postcode).append("',register='").append(register).append("',educated_degree='").append(educated_degree).append("',educated_years='").append(educated_years).append("',educated_major='").append(educated_major).append("',register_time='").append(register_time).append("',salary_standard_ID='").append(salary_standard_ID).append("',salary_standard_name='").append(salary_standard_name).append("',salary_sum='").append(salary_sum).append("',family_membership='").append(family_membership).append("',history_records='").append(history_records).append("',remark='").append(remark).append("',human_cellphone='").append(human_cellphone).append("',idcard='").append(idcard).append("',SIN='").append(SIN).append("',religion='").append(religion).append("',race='").append(race).append("',nationality='").append(nationality).append("',party='").append(party).append("',age='").append(age).append("',birthday='").append(birthday).append("',birthplace='").append(birthplace).append("',sex='").append(sex).append("',speciality='").append(speciality).append("',hobby='").append(hobby).append("',human_email='").append(human_email).append("' where human_ID='").append(human_ID).append("'").toString();
							hr_db.executeUpdate(sql8);
							CdefineUpdate CdefineUpdate = new CdefineUpdate();
							sql8 = CdefineUpdate.update("hr_file", "human_ID", human_ID, request);
							hr_db.executeUpdate(sql8);
							if (!chain_id.equals("oldChain_id"))
							{
								sql8 = (new StringBuilder("select id from hr_file where chain_id='")).append(oldChain_id).append("'").toString();
								ResultSet rs = hr_db.executeQuery(sql8);
								if (!rs.next())
								{
									sql8 = (new StringBuilder("update hr_config_file_kind set delete_tag='0' where file_id='")).append(oldChain_id).append("'").toString();
									hr_db.executeUpdate(sql8);
								}
								sql8 = (new StringBuilder("update hr_config_file_kind set delete_tag='1' where file_id='")).append(chain_id).append("'").toString();
								hr_db.executeUpdate(sql8);
							}
							String sql9 = (new StringBuilder("update security_users set human_name='")).append(human_name).append("' where human_ID='").append(human_ID).append("'").toString();
							hr_db.executeUpdate(sql9);
							String sql10 = (new StringBuilder("update security_license set human_name='")).append(human_name).append("' where human_ID='").append(human_ID).append("'").toString();
							hr_db.executeUpdate(sql10);
							response.sendRedirect((new StringBuilder("draft/hr/file_choose_picture.jsp?human_ID=")).append(human_ID).append("&tag=1").toString());
						}
						catch (Exception ex)
						{
							ex.printStackTrace();
						}
					else
						response.sendRedirect("draft/hr/file_ok.jsp?finished_tag=1");
				} else
				{
					SmartUpload mySmartUpload = new SmartUpload();
					mySmartUpload.setCharset("UTF-8");
					String human_ID = request.getParameter("human_ID");
					String file_type = "jpg,gif";
					long d = getFileLength.getFileLength((String)session.getAttribute("unit_db_name"));
					mySmartUpload.setMaxFileSize(d);
					mySmartUpload.setAllowedFilesList(file_type);
					mySmartUpload.initialize(pageContext);
					try
					{
						mySmartUpload.upload();
						SmartFile myFile = mySmartUpload.getFiles().getFile(0);
						ServletContext context = session.getServletContext();
						String path = context.getRealPath("/");
						String file = (new StringBuilder(String.valueOf(human_ID))).append(myFile.getFileName().substring(myFile.getFileName().length() - 4).toLowerCase()).toString();
						myFile.saveAs((new StringBuilder(String.valueOf(path))).append("hr/human_pictures/").append(file).toString());
						String sql = (new StringBuilder("update hr_file set picture='")).append(file).append("' where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sql);
						response.sendRedirect((new StringBuilder("draft/hr/file_choose_attachment.jsp?human_ID=")).append(human_ID).append("&&tag=").append(tag).toString());
					}
					catch (Exception ex)
					{
						response.sendRedirect("draft/hr/file_ok.jsp?finished_tag=6");
					}
				}
				hr_db.commit();
				hr_db.close();
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
}
